EMT Practice Test

1. Question Content...

---

Question1: True or False: Snowflake charges additional fees to Data providers for each share they create.

Question2: Which of the following statements are true of Snowflake data loading?
Choose 3 answers

Question3: What is the lowest Snowflake edition that offers Time Travel up to 90 days.

Question4: True or false: it is best practice to define a clustering key on every table.

Question5: In which layer of its architecture does Snowflake store its metadata statistics?
Select one.

Question6: How a Snowpipe charges calculated?

Question7: What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.

Question8: The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

Question9: True or False: Snowflake supports federated authentication in all editions.

Question10: A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

Question11: Which of the following are options when creating a virtual Warehouse?
Choose 2 answers

Question12: True or False: You can define multiple columns within a clustering key on a table.

Question13: Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.

Question14: Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

Question15: What is the most granular object that the Time Travel retention period can be defined on?
Select one.

Question16: Which interfaces can be used to create and/or manage Virtual Warehouses?

Question17: As a best practice, clustering keys should only be defined on tables of which minimum size?

Question18: Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Question19: Which of the following statements is true of Snowflake micro-partitioning?

Question20: Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Question21: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

Question22: Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Question23: The Query History in the Snowflake Web Interface (UI) is kept for approximately:

Question24: True or False: A single database can exist in more than one Snowflake account.

Question25: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Question26: Which statement best describes Snowflake tables?

Question27: Which are true of Snowflake roles?

Question28: Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.

Question29: Which of the following are options when creating a Virtual Warehouse?

Question30: Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Question31: True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

Question32: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Question33: Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

Question34: What is the recommended method for loading data into Snowflake?

Question35: True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

Question36: True or False: You can resize a Virtual Warehouse while queries are running.

Question37: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Question38: Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers

Question39: True or False: The COPY command must specify a File Format in order to execute.

Question40: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

Question41: Fail-safe is unavailable on which table types?

Question42: True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

Question43: The PUT command: (Choose two.)

Question44: What is the default File Format used in the COPY command if one is not specified?

Question45: Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:

Question46: True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Question47: True or False: It is possible to load data into Snowflake without creating a named File Format object.

Question48: True or False: All Snowflake table types include fail-safe storage.

Question49: True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

Question50: Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

Question51: How would you execute a series of SQL statements using Task?

Question52: Select the different types of Internal Stages: (Choose three.)

Question53: Which of the following items does the Cloud services Layer manage?
Choose 4 answers

Question54: True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Question55: True or False: Fail-safe can be disabled within a Snowflake account.

Question56: Which of the following is true of Snowpipe via REST API?
Choose 2 answers